package LawsonTransformJava.data;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;


public class TblEmAchDepst {
	public int    company		= 0;
	public int 	employee	=0; 
	public int 	ach_dist_nbr	=0; 
	public int	occurances	=0; 
	public int	remain_occur	=0; 
	public int 	ebank_id	=0; 
	public String 	ebnk_acct_nbr	=null; 
	public String 	account_type	=null; 
	public String 	ach_prenotify	=null; 
	public float 	net_percent	=0; 
	public float	deposit_amt	=0; 
	public String 	description	=null; 
	public String 	check_desc	=null; 
	public Date 	beg_date	=null; 
	public Date   	end_date	=null; 
	public String 	ded_cycle_01	=null; 
	public String 	ded_cycle_02	=null; 
	public String 	ded_cycle_03	=null; 
	public String 	ded_cycle_04	=null; 
	public String 	ded_cycle_05	=null; 
	public String 	ded_cycle_06	=null; 
	public String 	ded_cycle_07	=null; 
	public String 	ded_cycle_08	=null; 
	public String 	ded_cycle_09	=null; 
	public String 	default_flag	=null; 
	public String 	bank_roll_no	=null; 
	public int 		ach_dist_order	=0; 
	public int      ca_inst_nbr	=0; 
	public int		ca_transit_nbr	=0; 
	public String 	country_code	=null; 
	public String 	currency_code	=null; 
	public int		curr_nd		=0; 
	public int		pens_seq_nbr	=0; 
	public int		non_std_entry	=0; 
	public String 	orig_acct_nbr	=null; 
	public String 	payable_to	=null; 
	public String 	eadset2_ss_sw	=null; 
	public String 	eadset3_ss_sw	=null; 
	public String 	eadset4_ss_sw	=null; 
	public String 	eadset5_ss_sw	=null; 
	public String 	eadset7_ss_sw	=null; 
	public String 	eadset8_ss_sw	=null; 
	public Date 	create_date	=null; 
	public int      create_time	=0; 
	public String 	create_user_id	=null; 
	public Date 	date_stamp	=null; 
	public int      time_stamp	=0;  
	public String 	user_id		=null;
	
	private DateFormat df = new SimpleDateFormat("MM/dd/yyyy");
	private DateFormat df2 = new SimpleDateFormat("yyyyMMdd");
	private String text; 
	
	public void setCompany(int company) {
		this.company = company;
	}
	public void setEmployee(int employee) {
		this.employee = employee;
	}
	public void setAch_dist_nbr(int ach_dist_nbr) {
		this.ach_dist_nbr = ach_dist_nbr;
	}
	public void setOccurances(int occurances) {
		this.occurances = occurances;
	}
	public void setRemain_occur(int remain_occur) {
		this.remain_occur = remain_occur;
	}
	public void setEbank_id(int ebank_id) {
		this.ebank_id = ebank_id;
	}
	public void setEbnk_acct_nbr(String ebnk_acct_nbr) {
		this.ebnk_acct_nbr = ebnk_acct_nbr;
	}
	public void setAccount_type(String account_type) {
		this.account_type = account_type;
	}
	public void setAch_prenotify(String ach_prenotify) {
		this.ach_prenotify = ach_prenotify;
	}
	public void setNet_percent(float net_percent) {
		this.net_percent = net_percent;
	}
	public void setDeposit_amt(float deposit_amt) {
		this.deposit_amt = deposit_amt;
	}
	public void setDescription(String description) {
		this.description = description;
	}
	public void setCheck_desc(String check_desc) {
		this.check_desc = check_desc;
	}
	public void setBeg_date(Date beg_date) {
		this.beg_date = beg_date;
	}
	public void setEnd_date(Date end_date) {
		this.end_date = end_date;
	}
	public void setDed_cycle_01(String ded_cycle_01) {
		this.ded_cycle_01 = ded_cycle_01;
	}
	public void setDed_cycle_02(String ded_cycle_02) {
		this.ded_cycle_02 = ded_cycle_02;
	}
	public void setDed_cycle_03(String ded_cycle_03) {
		this.ded_cycle_03 = ded_cycle_03;
	}
	public void setDed_cycle_04(String ded_cycle_04) {
		this.ded_cycle_04 = ded_cycle_04;
	}
	public void setDed_cycle_05(String ded_cycle_05) {
		this.ded_cycle_05 = ded_cycle_05;
	}
	public void setDed_cycle_06(String ded_cycle_06) {
		this.ded_cycle_06 = ded_cycle_06;
	}
	public void setDed_cycle_07(String ded_cycle_07) {
		this.ded_cycle_07 = ded_cycle_07;
	}
	public void setDed_cycle_08(String ded_cycle_08) {
		this.ded_cycle_08 = ded_cycle_08;
	}
	public void setDed_cycle_09(String ded_cycle_09) {
		this.ded_cycle_09 = ded_cycle_09;
	}
	public void setDefault_flag(String default_flag) {
		this.default_flag = default_flag;
	}
	public void setBank_roll_no(String bank_roll_no) {
		this.bank_roll_no = bank_roll_no;
	}
	public void setAch_dist_order(int ach_dist_order) {
		this.ach_dist_order = ach_dist_order;
	}
	public void setCa_inst_nbr(int ca_inst_nbr) {
		this.ca_inst_nbr = ca_inst_nbr;
	}
	public void setCa_transit_nbr(int ca_transit_nbr) {
		this.ca_transit_nbr = ca_transit_nbr;
	}
	public void setCountry_code(String country_code) {
		this.country_code = country_code;
	}
	public void setCurrency_code(String currency_code) {
		this.currency_code = currency_code;
	}
	public void setCurr_nd(int curr_nd) {
		this.curr_nd = curr_nd;
	}
	public void setPens_seq_nbr(int pens_seq_nbr) {
		this.pens_seq_nbr = pens_seq_nbr;
	}
	public void setNon_std_entry(int non_std_entry) {
		this.non_std_entry = non_std_entry;
	}
	public void setOrig_acct_nbr(String orig_acct_nbr) {
		this.orig_acct_nbr = orig_acct_nbr;
	}
	public void setPayable_to(String payable_to) {
		this.payable_to = payable_to;
	}
	public void setEadset2_ss_sw(String eadset2_ss_sw) {
		this.eadset2_ss_sw = eadset2_ss_sw;
	}
	public void setEadset3_ss_sw(String eadset3_ss_sw) {
		this.eadset3_ss_sw = eadset3_ss_sw;
	}
	public void setEadset4_ss_sw(String eadset4_ss_sw) {
		this.eadset4_ss_sw = eadset4_ss_sw;
	}
	public void setEadset5_ss_sw(String eadset5_ss_sw) {
		this.eadset5_ss_sw = eadset5_ss_sw;
	}
	public void setEadset7_ss_sw(String eadset7_ss_sw) {
		this.eadset7_ss_sw = eadset7_ss_sw;
	}
	public void setEadset8_ss_sw(String eadset8_ss_sw) {
		this.eadset8_ss_sw = eadset8_ss_sw;
	}
	public void setCreate_date(Date create_date) {
		this.create_date = create_date;
	}
	public void setCreate_time(int create_time) {
		this.create_time = create_time;
	}
	public void setCreate_user_id(String create_user_id) {
		this.create_user_id = create_user_id;
	}
	public void setDate_stamp(Date date_stamp) {
		this.date_stamp = date_stamp;
	}
	public void setTime_stamp(int time_stamp) {
		this.time_stamp = time_stamp;
	}
	public void setUser_id(String user_id) {
		this.user_id = user_id;
	}
	public int getCompany() {
		return company;
	}
	public int getEmployee() {
		return employee;
	}
	public int getAch_dist_nbr() {
		return ach_dist_nbr;
	}
	public int getOccurances() {
		return occurances;
	}
	public int getRemain_occur() {
		return remain_occur;
	}
	public int getEbank_id() {
		return ebank_id;
	}
	public String getEbnk_acct_nbr() {
		if (ebnk_acct_nbr==null||ebnk_acct_nbr.equals(""))
		{text = "";}
	else
		{text = "\""+ebnk_acct_nbr+"\"";}
	return text;
	}
	public String getAccount_type() {
		if (account_type==null||account_type.equals(""))
		{text = "";}
	else
		{text = "\""+account_type+"\"";}
	return text;	
	}
	public String getAch_prenotify() {
		if (ach_prenotify==null||ach_prenotify.equals(""))
		{text = "";}
	else
		{text = "\""+ach_prenotify+"\"";}
	return text;
	}
	public float getNet_percent() {
		return net_percent;
	}
	public float getDeposit_amt() {
		return deposit_amt;
	}
	public String getDescription() {
		if (description==null||description.equals(""))
		{text = "";}
	else
		{text = "\""+description+"\"";}
	return text;
	}
	public String getCheck_desc() {
		if (check_desc==null||check_desc.equals(""))
		{text = "";}
	else
		{text = "\""+check_desc+"\"";}
	return text;
	}
	public String getBeg_date() {
		if (beg_date==null)
		{text = "";}
		else
		{String date =(beg_date!=null?df2.format(beg_date).toString():""); 
		if (date.equals("17000101") || date.equals("16991219"))
			{text = "";}
		else
			{text ="\"" + df.format(beg_date).toString() + "\"";;}}
		return text;	
	}
	public String getEnd_date() {
		if (end_date==null)
		{text = "";}
		else
		{String date =(end_date!=null?df2.format(end_date).toString():""); 
		if (date.equals("17000101") || date.equals("16991219"))
			{text = "";}
		else
			{text ="\"" + df.format(end_date).toString() + "\"";;}}
		return text;	
	}
	public String getDed_cycle_01() {
		if (ded_cycle_01==null||ded_cycle_01.equals(""))
		{text = "";}
	else
		{text = "\""+ded_cycle_01+"\"";}
	return text;
		}
	public String getDed_cycle_02() {
		if (ded_cycle_02==null||ded_cycle_02.equals(""))
		{text = "";}
	else
		{text = "\""+ded_cycle_02+"\"";}
	return text;
	}
	public String getDed_cycle_03() {
		if (ded_cycle_03==null||ded_cycle_03.equals(""))
		{text = "";}
	else
		{text = "\""+ded_cycle_03+"\"";}
	return text;
	}
	public String getDed_cycle_04() {
		if (ded_cycle_04==null||ded_cycle_04.equals(""))
		{text = "";}
	else
		{text = "\""+ded_cycle_04+"\"";}
	return text;
	}
	public String getDed_cycle_05() {
		if (ded_cycle_05==null||ded_cycle_05.equals(""))
		{text = "";}
	else
		{text = "\""+ded_cycle_05+"\"";}
	return text;
	}
	public String getDed_cycle_06() {
		if (ded_cycle_06==null||ded_cycle_06.equals(""))
		{text = "";}
	else
		{text = "\""+ded_cycle_06+"\"";}
	return text;
	}
	public String getDed_cycle_07() {
		if (ded_cycle_07==null||ded_cycle_07.equals(""))
		{text = "";}
	else
		{text = "\""+ded_cycle_07+"\"";}
	return text;
	}
	public String getDed_cycle_08() {
		if (ded_cycle_08==null||ded_cycle_08.equals(""))
		{text = "";}
	else
		{text = "\""+ded_cycle_08+"\"";}
	return text;
	}
	public String getDed_cycle_09() {
		if (ded_cycle_09==null||ded_cycle_09.equals(""))
		{text = "";}
	else
		{text = "\""+ded_cycle_09+"\"";}
	return text;
	}
	public String getDefault_flag() {
		if (default_flag==null||default_flag.equals(""))
		{text = "";}
	else
		{text = default_flag;}
	return text;		
	}
	public String getBank_roll_no() {
		if (bank_roll_no==null||bank_roll_no.equals(""))
		{text = "";}
	else
		{text = "\""+bank_roll_no+"\"";}
	return text;
	}
	public int getAch_dist_order() {
		return ach_dist_order;
	}
	public int getCa_inst_nbr() {
		return ca_inst_nbr;
	}
	public int getCa_transit_nbr() {
		return ca_transit_nbr;
	}
	public String getCountry_code() {
		if (country_code==null||country_code.equals(""))
		{text = "";}
	else
		{text = "\""+country_code+"\"";}
	return text;		
	}
	public String getCurrency_code() {
		if (currency_code==null||currency_code.equals(""))
		{text = "";}
	else
		{text = "\""+currency_code+"\"";}
	return text;		
	}
	public int getCurr_nd() {
		return curr_nd;
	}
	public int getPens_seq_nbr() {
		return pens_seq_nbr;
	}
	public int getNon_std_entry() {
		return non_std_entry;
	}
	public String getOrig_acct_nbr() {
		if (orig_acct_nbr==null||orig_acct_nbr.equals(""))
		{text = "";}
	else
		{text = "\""+orig_acct_nbr+"\"";}
	return text;		
	}
	public String getPayable_to() {
		if (payable_to==null||payable_to.equals(""))
		{text = "";}
	else
		{text = "\""+payable_to+"\"";}
	return text;		
	}
	public String getEadset2_ss_sw() {
		if (eadset2_ss_sw==null||eadset2_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+eadset2_ss_sw+"\"";}
	return text;		
	}
	public String getEadset3_ss_sw() {
		if (eadset3_ss_sw==null||eadset3_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+eadset3_ss_sw+"\"";}
	return text;
	}
	public String getEadset4_ss_sw() {
		if (eadset4_ss_sw==null||eadset4_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+eadset4_ss_sw+"\"";}
	return text;
	}
	public String getEadset5_ss_sw() {
		if (eadset5_ss_sw==null||eadset5_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+eadset5_ss_sw+"\"";}
	return text;
	}
	public String getEadset7_ss_sw() {
		if (eadset7_ss_sw==null||eadset7_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+eadset7_ss_sw+"\"";}
	return text;
	}
	public String getEadset8_ss_sw() {
		if (eadset8_ss_sw==null||eadset8_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+eadset8_ss_sw+"\"";}
	return text;
	}
	public String getCreate_date() {
		if (create_date==null)
		{text = "";}
		else
		{String date =(create_date!=null?df2.format(create_date).toString():""); 
		if (date.equals("17000101"))
			{text = "";}
		else
			{text ="\"" + df.format(create_date).toString() + "\"";;}}
		return text;	
	}
	public int getCreate_time() {
		return create_time;
	}
	public String getCreate_user_id() {
		if (create_user_id==null||create_user_id.equals(""))
		{text = "";}
	else
		{text = "\""+create_user_id+"\"";}
	return text;		
	}
	public String getDate_stamp() {
		if (date_stamp==null)
		{text = "";}
		else
		{String date =(date_stamp!=null?df2.format(date_stamp).toString():""); 
		if (date.equals("17000101"))
			{text = "";}
		else
			{text ="\"" + df.format(date_stamp).toString() + "\"";;}}
		return text;	
	}
	public int getTime_stamp() {
		return time_stamp;
	}
	public String getUser_id() {
		if (user_id==null||user_id.equals(""))
		{text = "";}
	else
		{text = "\""+user_id+"\"";}
	return text;		
	} 
	
	
}
